package net.lookyou.boot.demo.mapper;

import net.lookyou.boot.demo.entity.UserRole;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UserRoleMapper {

    @Select(value = "select u.id,u.name,r.roleName from t_user u,t_role r where u.roleId = r.id")
    List<UserRole> queryUserList();
}